<?php


include('../classess/class_manage_user.php');
include('../classess/class_affiliate_user.php');
$manage_user = new manageUser();
$affUser = new affUser();

if (isset($_POST['export_csv'])) {
    $manage_user->export_csv($_GET['aff_id'], $_POST);
}

include_once('header.php');
?>

<?php include_once('left_navigation.php'); ?>
<style type="text/css">

    .datepicker{

        z-index: 99999999999;

    }

</style>
<?php
if (isset($_GET['aff_id'])) {
    $affiliate_id = $_GET['aff_id'];
    $manageUser = '';
    if (isset($_POST['bank_name']) && $_POST['bank_name'] != '') {

        $manageUser = $manage_user->bankdetail_add($affiliate_id, 'user_affiliate');
    }
    $banks_details = $manage_user->get_details($affiliate_id);
}
$affiliate_username = $affUser->get_aff_user($_GET['aff_id']);
?>

<div class="col-lg-12"><!-- Start Middle Content Div-->

    <div class="box">

        <div class="row">		

            <div class="col-lg-12">

                <div class="box">

                    <div class="box-header" data-original-title>

                        <h2><i class="fa fa-user"></i><span class="break"></span>Affiliate Name: <?php echo $affiliate_username[0]->username; ?></h2>

                        <div class="box-icon">

                            <a href="table.html#" class="btn-minimize"><i class="fa fa-chevron-up"></i></a>

                            <a href="table.html#" class="btn-close"><i class="fa fa-times"></i></a>

                        </div>

                    </div>

                    <div class="box-content">

                        <?php
                        if (isset($_GET['aff_id'])) {

                            if ($_GET['aff_id'] != '') {
                                ?>



                                <div class="search_box">

                                    <!--<div class="fl_left sel_label_search">Search:</div>
                                    
                                    <div class="fl_left" style="width:60%;">									
                                    
                                    <form method="POST" action="<?php echo $_SERVER['PHP_SELF']; ?>?aff_prg=1&aff_id=<?php echo $_GET['aff_id']; ?>" id="search_form" name="search_form">
                                    
                                    <input type="text" name="search_value" id="search_value" placeholder="Search" value="<?php
                                    if (isset($_POST['search_value'])) {
                                        echo $_POST['search_value'];
                                    } else {
                                        echo '';
                                    } if (isset($_GET['srch_value'])) {
                                        echo $_GET['srch_value'];
                                    } else {
                                        echo '';
                                    }
                                    ?>">&nbsp;
                                    
                                    <input type="submit" name="submit_search" id="submit_search" class="btn btn-blue srch_btn" value="Search">
                                    
                                    </form>
                                    
                                    
                                    
                                    </div>
                                    
                                    <div class="clear_fix"></div>-->

                                    <form method="POST" action="<?php echo $_SERVER['PHP_SELF']; ?>?aff_prg=1&aff_id=<?php echo $_GET['aff_id']; ?>" id="search_form" name="search_form">

                                        <div class="fl_left" style="width:60%;">

                                            <div class="fl_left sel_label_search" style="width:11%;">Search:</div>

                                            <div class="fl_left" style="width:86%;">	

                                                <input type="text" name="search_value" id="search_value" placeholder="Search" value="<?php
                                                if (isset($_POST['search_value'])) {
                                                    echo $_POST['search_value'];
                                                } else {
                                                    echo '';
                                                } if (isset($_GET['srch_value'])) {
                                                    echo $_GET['srch_value'];
                                                } else {
                                                    echo '';
                                                }
                                                ?>" style="width:27%;">&nbsp;

                                                Date
                                                <input type="text" class="date-picker" name="from_date" id="from_date" value="<?php
                                                if (isset($_POST['from_date'])) {
                                                    echo $_POST['from_date'];
                                                } else {
                                                    echo '';
                                                } if (isset($_GET['from_date'])) {
                                                    echo $_GET['from_date'];
                                                } else {
                                                    echo '';
                                                }
                                                ?>" style="width:20%;" />
                                                To 
                                                <input type="text" class="date-picker" name="to_date" id="to_date" value="<?php
                                                if (isset($_POST['to_date'])) {
                                                    echo $_POST['to_date'];
                                                } else {
                                                    echo '';
                                                } if (isset($_GET['to_date'])) {
                                                    echo $_GET['to_date'];
                                                } else {
                                                    echo '';
                                                }
                                                ?>"  style="width:20%;" />

                                                <input type="submit" name="submit_search" id="submit_search" class="btn btn-blue srch_btn" value="Search">										

                                            </div>

                                            <div class="clear_fix"></div>

                                        </div>

                                        <div class="fl_right">

                                            <div class="fl_left" style="width:15%; margin-top:5px;">Number Of Records : </div>

                                            <div class="fl_left">

                                                <?php
                                                $limit_10 = '';

                                                $limit_25 = '';

                                                $limit_50 = '';

                                                $limit_100 = '';

                                                if (isset($_POST['sel_limit'])) {

                                                    /*if ($_POST['sel_limit'] == '10') {

                                                        $limit_10 = "selected='selected'";
                                                    }*/

                                                    if ($_POST['sel_limit'] == '25') {

                                                        $limit_25 = "selected='selected'";
                                                    }

                                                    if ($_POST['sel_limit'] == '50') {

                                                        $limit_50 = "selected='selected'";
                                                    }

                                                    if ($_POST['sel_limit'] == '100') {

                                                        $limit_100 = "selected='selected'";
                                                    }
                                                }

                                                if (isset($_GET['sel_get_limit'])) {

                                                /*    if ($_GET['sel_get_limit'] == '10') {

                                                        $limit_10 = "selected='selected'";
                                                    }
*/
                                                    if ($_GET['sel_get_limit'] == '25') {

                                                        $limit_25 = "selected='selected'";
                                                    }

                                                    if ($_GET['sel_get_limit'] == '50') {

                                                        $limit_50 = "selected='selected'";
                                                    }

                                                    if ($_GET['sel_get_limit'] == '100') {

                                                        $limit_100 = "selected='selected'";
                                                    }
                                                }
                                                ?>

                                                <select name="sel_limit" id="sel_limit" onchange="javascript:document.search_form.submit();">

                                                <!--    <option value="10" <?php echo $limit_10; ?> >10</option>
-->
                                                    <option value="25" <?php echo $limit_25; ?> >25</option>

                                                    <option value="50" <?php echo $limit_50; ?> >50</option>

                                                    <option value="100" <?php echo $limit_100; ?> >100</option>

                                                </select>

                                                &nbsp;&nbsp;&nbsp;&nbsp;
                                                <input type="submit" name="export_csv" id="export_csv" class="btn btn-blue srch_btn" value="Export CSV">


                                            </div>

                                            <div class="clear_fix"></div>

                                        </div>

                                        <div class="clear_fix"></div>							

                                    </form>

                                </div>

                                <table class="table table-striped table-bordered">

                                    <thead>

                                        <tr>

                                            <th>S.No.</th>

                                            <th>User Name</th>

                                            <th>Email</th>

                                            <th>Date</th>
                                            <th>Price</th>

                                            <th>Is Active</th>

                                            <th>Is Paid</th>
                                            <th>&nbsp;</th>

                                        </tr>

                                    </thead>   

                                    <tbody>

                                        <?php
                                        $rec_limit = 25;

                                        if (isset($_POST['sel_limit'])) {

                                            $rec_limit = $_POST['sel_limit'];
                                        }



                                        if (isset($_GET['sel_get_limit'])) {

                                            $rec_limit = $_GET['sel_get_limit'];
                                        }



                                        $condition_search = '';

                                        $value = '';

                                        if (isset($_POST['search_value'])) {

                                            $value = trim($_POST['search_value']);

                                            if (!empty($value)) {

                                                $cond_where = 'AND ';

                                                $condition_search = $cond_where . " (username like '%" . $value . "%' OR email like '%" . $value . "%')";
                                            }
                                        }


                                        if (isset($_POST['from_date']) && $_POST['from_date'] == '1970-01-01') {

                                            $from_date = date('Y-m-d', strtotime(trim($_POST['from_date'])));
                                            $to_date = date('Y-m-d', strtotime(trim($_POST['to_date'])));
                                            $cond_where = 'AND ';
                                            $condition_search .= $cond_where . " ur.create_ts BETWEEN '" . $from_date . "' AND '" . $to_date . "' ";
                                        }



                                        if (isset($_GET['srch_value'])) {

                                            $value = $_GET['srch_value'];



                                            if (!empty($value)) {

                                                $cond_where = 'AND ';



                                                $condition_search = $cond_where . " (username like '%" . $value . "%' OR email like '%" . $value . "%')";
                                            }
                                        }



                                        
                                      /*  $select_count_course = "SELECT  count(*)  FROM tbl_user AS u 
JOIN tbl_commission AS c ON c.`trainee_id` = u.`id` 
JOIN tbl_user_details AS ud ON c.`trainee_detail_id` = ud.`id` 
WHERE  u.reffered_by = 'a_" . $_GET['aff_id'] . "' AND ud.`is_refund` = '0' " . $condition_search . "
GROUP BY u.username ORDER BY u.username DESC" ;
*/
                                        $select_count_course = "select  count(*)  
,(SELECT SUM(c.`commission`) AS total_user_commission FROM tbl_commission c LEFT JOIN  tbl_user_details AS ud ON c.`trainee_detail_id` = ud.`id`  WHERE c.`trainee_id` = u.`id` AND ud.`is_refund` = '0') as total_user_commission 
FROM tbl_user AS u 
WHERE  u.reffered_by = 'a_" . $_GET['aff_id'] . "'  " . $condition_search . " ";

                                        $result_count_course = mysql_query($select_count_course);



                                        $row = mysql_fetch_array($result_count_course);

                                        $rec_count = $row[0];



                                        if (isset($_GET['page'])) {
                                            $page = $_GET['page'] + 1;
                                            $offset = $rec_limit * $page;
                                        } else {
                                            $page = 0;
                                            $offset = 0;
                                        }
                                        $serial_number = $page * $rec_limit;
                                        $left_rec = $rec_count - ($page * $rec_limit);

                                        /*                                      $select_trainer = "SELECT *,ur.id as user_id FROM tbl_user as ur 
                                          LEFT JOIN tbl_commission as com ON com.user_admin_id = 'a_" . $_GET['aff_id'] . "'
                                          WHERE reffered_by='a_" . $_GET['aff_id'] . "'
                                          " . $condition_search . " GROUP BY ur.id ORDER BY ur.id DESC LIMIT " . $offset . ", " . $rec_limit;
                                         */
                                        
                                        
                                        $select_trainer = " 
SELECT  u.id AS user_id, u.*  
,(SELECT SUM(c.`commission`) AS total_user_commission FROM tbl_commission c LEFT JOIN  tbl_user_details AS ud ON c.`trainee_detail_id` = ud.`id`  WHERE c.`trainee_id` = u.`id` AND ud.`is_refund` = '0') as total_user_commission 
FROM tbl_user AS u 
WHERE  u.reffered_by = 'a_" . $_GET['aff_id'] . "'  " . $condition_search . " 
GROUP BY u.username ORDER BY u.username DESC LIMIT " . $offset . ", " . $rec_limit;
                                        
                                        /*
                                        $select_trainer = "SELECT  SUM(c.`commission`) as total_user_commission,u.id as user_id, u.*  FROM tbl_user AS u 
                                                        JOIN tbl_commission AS c ON c.`trainee_id` = u.`id` 
                                                        JOIN tbl_user_details AS ud ON c.`trainee_detail_id` = ud.`id` 
                                                        WHERE  u.reffered_by = 'a_" . $_GET['aff_id'] . "' AND ud.`is_refund` = '0' " . $condition_search . "
                                                        GROUP BY u.username ORDER BY u.username DESC LIMIT " . $offset . ", " . $rec_limit;
*/
                                        $query_trainer = mysql_query($select_trainer) or die(mysql_error());



                                        $i = 1;

                                        if (mysql_num_rows($query_trainer) > 0) {
                                            $total_amount = '0';
                                            $pending_amount = '0';
                                            $paid_amount = '0';
                                            while ($row = mysql_fetch_array($query_trainer)) {
                                                $select_paidamount = "SELECT SUM(total_amount) AS total_amount FROM tbl_aff_transfer  WHERE at_affilate_id= '" . $_GET['aff_id'] . "'";
                                                $query_paidamount = mysql_query($select_paidamount) or die(mysql_error());
                                                $total_paidamount = mysql_fetch_assoc($query_paidamount);
                                                if ($row['is_active'] && $row['is_paid']) {
                                                    $total_amount += $row['total_user_commission'];
                                                }
                                                $paid_amount = $total_paidamount['total_amount'];
                                                $pending_amount = $row['total_user_commission'] - $total_paidamount['total_amount'];
                                                echo '

<tr>

<td>' . $i . '</td>

<td>' . $row['username'] . '</td>

<td>' . $row['email'] . '</td>
<td>' . $row['create_ts'] . '</td>';
                                                if ($row['is_active'] && $row['is_paid']) {
                                                    echo '<td>$' . $row['total_user_commission'] . '</td>';
                                                } else {
                                                    echo '<td></td>';
                                                }


                                                echo '<td>';

                                                if ($row['is_active']) {

                                                    echo '<span class="label label-success">Active</span>';
                                                } else {

                                                    echo '<span class="label label-default">Inactive</span>';
                                                }

                                                echo '</td>

<td>';

                                                if ($row['is_paid']) {

                                                    echo '<span class="label label-success">Yes</span>';
                                                } else {

                                                    echo '<span class="label label-default">No</span>';
                                                }

                                                echo '</td>



';
                                                echo '</td>';
                                                echo '<td><a href="user_course.php?home=1&user_id=' . $row['user_id'] . '">View Info</a></td>
	</tr>
										';

                                                $i++;
                                            }
                                        } else {

                                            echo '<tr>

<td colspan="9" style="text-align:center;">No Records Found</td>

</tr>';
                                        }
                                        ?>							

                                    </tbody>

                                </table>  

                                <?php
                                echo '<ul class="pagination">';

                                if ($rec_count > $rec_limit) {

                                    if ($page > 0 && $left_rec > $rec_limit) {

                                        $last = $page - 2;

                                        echo '<li><a href="' . $_SERVER["PHP_SELF"] . '?aff_prg=1&aff_id=' . $_GET['aff_id'] . '&page=' . $last . '&srch_value=' . $value . '&sel_get_limit=' . $rec_limit . '" class="anc_click">Prev</a></li> ';

                                        echo '<li><a href="' . $_SERVER["PHP_SELF"] . '?aff_prg=1&aff_id=' . $_GET['aff_id'] . '&page=' . $page . '&srch_value=' . $value . '&sel_get_limit=' . $rec_limit . '" class="anc_click">Next</a></li>';
                                    } else if ($page == 0) {

                                        echo '<li><a href="' . $_SERVER["PHP_SELF"] . '?aff_prg=1&aff_id=' . $_GET['aff_id'] . '&page=' . $page . '&srch_value=' . $value . '&sel_get_limit=' . $rec_limit . '" class="anc_click">Next</a></li>';
                                    } else if ($left_rec < $rec_limit || $left_rec == $rec_limit) {

                                        $last = $page - 2;

                                        echo '<li><a href="' . $_SERVER["PHP_SELF"] . '?aff_prg=1&aff_id=' . $_GET['aff_id'] . '&page=' . $last . '&srch_value=' . $value . '&sel_get_limit=' . $rec_limit . '" class="anc_click">Prev</a></li>';
                                    }
                                }

                                echo '</ul>';
                                ?><br/><br/>

                                <?php
                                $select_value = "SELECT * FROM tbl_affiliate  WHERE id = '" . $_GET['aff_id'] . "'";

                                $query_value = mysql_query($select_value) or die(mysql_error());
                                $withdrawData = mysql_fetch_assoc($query_value);
                                ?>
                                <div>
                                    <p><b>Minimum Amount:</b>  $ <?php
                                        echo $withdrawData['withdraw_min_amount'];
                                        ;
                                        ?></p>
                                    <p><b>Maximum Amount:</b>  $ <?php echo $withdrawData['withdraw_max_amount']; ?></p>
                                </div>

                                <?php if ($total_amount != '') { ?>                                            
                                    <p><b>Total Amount:</b>  $ <?php echo $total_amount; ?></p>
                                <?php } ?>
                                <?php if ($paid_amount != '') { ?>                                            
                                    <p><b>Paid Amount:</b>  $ <?php echo $paid_amount; ?></p>
                                <?php } ?>
                                <?php //if($pending_amount != ''){  ?>                                            
                                <p><b>Pending Amount:</b>  $ <?php echo $pending_amount; ?></p>
                                <?php //}  ?>

                                <?php
                            }
                        }
                        ?>

                    </div>

                </div>

            </div><!--/col-->



        </div><!--/row-->



        <div class="col-lg-12"><!-- Start Middle Content Div-->

            <div class="box">

                <div class="box-header" data-original-title=""><!-- Start Box Header Div-->

                    <h2><i class="fa fa-edit"></i><span class="break"></span>Add Detail</h2>

                    <div class="box-icon">

                        <a href="gallery.html#" class="btn-minimize"><i class="fa fa-chevron-up"></i></a>

                        <a href="gallery.html#" class="btn-close"><i class="fa fa-times"></i></a>

                    </div>

                </div><!-- End Box Header Div-->


                <div class="box-content"><!-- Start Box Content Div-->

                    <div class="row">

                        <div class="col-sm-12">

                            <?php if ($manageUser) { ?>
                                <div class="alert alert-info">

                                    <div style="float: right; width: 5%;"><button type="button" class="close" data-dismiss="alert">&times;</button></div>

                                    <div style="float:left;width: 92%;word-wrap: break-word;"><?php echo $manageUser; ?></div>

                                    <div style="clear:both;"></div>							

                                </div>
                                <?php
                            }



                            $select_pending = "SELECT  SUM(c.`commission`) as total_user_commission,u.id as user_id, u.*  FROM tbl_user AS u 
                                            JOIN tbl_commission AS c ON c.`trainee_id` = u.`id` 
                                            JOIN tbl_user_details AS ud ON c.`trainee_detail_id` = ud.`id` 
                                            WHERE  u.reffered_by = 'a_" . $_GET['aff_id'] . "' AND ud.`is_refund` = '0' 
                                            GROUP BY u.username ORDER BY u.username DESC  ";

                            $query_pending = mysql_query($select_pending) or die(mysql_error());
                            $total_amount = '';
                            $pending_amount = '';
                            while ($row = mysql_fetch_array($query_pending)) {
                                $select_paidamount = "SELECT SUM(total_amount) AS total_amount FROM tbl_aff_transfer  WHERE at_affilate_id= '" . $_GET['aff_id'] . "'";
                                $query_paidamount = mysql_query($select_paidamount) or die(mysql_error());
                                $total_paidamount = mysql_fetch_assoc($query_paidamount);
                                if ($row['is_active'] && $row['is_paid']) {
                                    $total_amount += $row['total_user_commission'];
                                }
                                $paid_amount = $total_paidamount['total_amount'];
                                $pending_amount = $total_amount - $total_paidamount['total_amount'];
                            }
                            ?>
                            <form method="POST" action="<?php echo $_SERVER['PHP_SELF']; ?>?aff_prg=1&aff_id=<?php echo $_GET['aff_id'] ?>" name="add_aff_bank_detail" id="add_aff_bank_detail" enctype="multipart/form-data">

                                <div class="main_form_box col-sm-6">

                                    <div class="form-content  form-content-form">								

                                        <label>Bank Name</label>
                                        <input type="text" name="bank_name" id="bank_name" value="" > 

                                        <label>Account Number</label>
                                        <input type="text" name="account_number" id="account_number" value="" >

                                        <label>Transaction Id</label>
                                        <input type="text" name="transaction_id" id="transaction_id" value="" >

                                        <label>Date</label>
                                        <input readonly type="text" name="at_date" id="at_date" class="date-picker" value="">	
                                    </div>

                                </div>

                                <div class="main_form_box col-sm-6" >

                                    <div class="form-content  form-content-form">

                                        <label>Tds (%)</label>
                                        <input readonly type="text" name="tds" id="tds" value="10" >

                                        <label>Pending Amount</label>
                                        <input type="text" readonly="readonly" name="pending_amount" id="pending_amount" value="<?php echo $pending_amount; ?>" >

                                        <label>Total Amount</label>
                                        <input type="text" name="total_amount" id="total_amount" value=""> 

                                        <label>Total Amount with Tds</label>
                                        <input type="text" readonly="readonly" name="total_amount_with_tds" id="total_amount_with_tds" value=""> 


                                        <label>Note</label>
                                        <textarea  rows="5" cols="40" name="at_note" id="at_note" value=""></textarea>

                                        <label style="text-align:right; margin-top:35px;">

                                            <button type="button" class="btn btn-blue login_button" name="add_bank_detail" id="add_bank_detail">
                                                Add
                                            </button> 							

                                        </label>

                                    </div>

                                </div>


                                <div style="clear:both;"></div>

                            </form>

                        </div><!--/col-->

                    </div><!-- End Row div -->

                </div><!-- End Box Content Div -->

            </div><!-- End Box Div-->

        </div><!-- End Middle Content Div-->

        <div class="row">		

            <div class="col-lg-12">

                <div class="box">

                    <div class="box-header" data-original-title>

                        <h2><i class="fa fa-user"></i><span class="break"></span>Bank Detail</h2>

                        <div class="box-icon">

                            <a href="table.html#" class="btn-minimize"><i class="fa fa-chevron-up"></i></a>

                            <a href="table.html#" class="btn-close"><i class="fa fa-times"></i></a>

                        </div>

                    </div>

                    <div class="box-content">


                        <div class="search_box">

                            <!--                         <div class="fl_left sel_label_search">Search:</div>
                         
                                                     <div class="fl_left" style="width:60%;">									
                         
                                                         <form method="POST" action="<?php echo $_SERVER['PHP_SELF']; ?>?aff_mn=1" id="search_form" name="search_form">
                         
                                                             <input type="text" name="search_value" id="search_value" placeholder="Search" value="<?php
                            if (isset($_POST['search_value'])) {
                                echo $_POST['search_value'];
                            } else {
                                echo '';
                            } if (isset($_GET['srch_value'])) {
                                echo $_GET['srch_value'];
                            } else {
                                echo '';
                            }
                            ?>">&nbsp;
                         
                                                             <input type="submit" name="submit_search" id="submit_search" class="btn btn-blue srch_btn" value="Search">
                         
                                                         </form>
                         
                         
                         
                                                     </div>
                            -->
                            <div class="clear_fix"></div>

                        </div>

                        <table class="table table-striped table-bordered">
                            <thead>
                                <tr>
                                    <th>S.No.</th>
                                    <th>Bank Name</th>
                                    <th>Account No.</th>
                                    <th>Transaction Id</th>
                                    <th>Transfer Amount</th>
                                    <th>Tds(%)</th>
                                    <th>Receive Amount</th>
                                    <th>Date</th>
                                    <th>Note</th>
                                </tr>

                            </thead>   

                            <tbody>

                                <?php
                                $rec_limits = 3;



                                $condition_search = '';

                                $value = '';
                                /*
                                  if (isset($_POST['search_value'])) {
                                  $value = trim($_POST['search_value']);
                                  if (!empty($value)) {
                                  $cond_where = ' AND';
                                  $condition_search = $cond_where . " (b.username like '%" . $value . "%' OR b.email_id like '%" . $value . "%')";
                                  }
                                  }
                                  if (isset($_GET['srch_value'])) {
                                  $value = $_GET['srch_value'];
                                  if (!empty($value)) {
                                  $cond_where = ' AND';
                                  $condition_search = $cond_where . " (b.username like '%" . $value . "%' OR b.email_id like '%" . $value . "%')";
                                  }
                                  }
                                 */


                                $select_count_detail = "SELECT count(at_id) FROM tbl_aff_transfer WHERE at_affilate_id= '" . $_GET['aff_id'] . "'" . $condition_search;

                                $result_count_detail = mysql_query($select_count_detail);



                                $row_detail = mysql_fetch_array($result_count_detail);

                                $rec_count_detail = $row_detail[0];



                                if (isset($_GET['pages'])) {

                                    $pages = $_GET['pages'] + 1;

                                    $offsets = $rec_limits * $pages;
                                } else {

                                    $pages = 0;

                                    $offsets = 0;
                                }
                                $serial_numbers = $pages * $rec_limits;
                                $left_recs = $rec_count - ($pages * $rec_limits);
                                $select_bank = "SELECT * FROM tbl_aff_transfer WHERE at_affilate_id= '" . $_GET['aff_id'] . "'" . $condition_search . " ORDER BY at_id DESC LIMIT " . $offset . ", " . $rec_limit;
                                $query_bank = mysql_query($select_bank) or die(mysql_error());

                                $i = 1;

                                if (mysql_num_rows($query_bank) > 0) {

                                    while ($rows = mysql_fetch_array($query_bank)) {

                                        $serial_numbers++;

                                        echo '
						<tr><td>' . $serial_numbers . '</td>
						<td>' . $rows['bank_name'] . '</td>
						<td>' . $rows['account_number'] . '</td>
        					<td>' . $rows['transaction_id'] . '</td>
                                                <td> $ ' . $rows['total_amount'] . '</td>
                                                    <td>' . $rows['tds'] . '</td>
                                                         <td> $ ' . $rows['total_amount_with_tds'] . '</td>
						<td>' . $rows['at_date'] . '</td>
                                                <td>' . $rows['at_note'] . '</td>';
                                        echo '
        						</tr>

										';

                                        $i++;
                                    }
                                } else {

                                    echo '<tr>

										<td colspan="9" style="text-align:center;">No Records Found</td>

									</tr>';
                                }
                                ?>						

                            </tbody>

                        </table>  

                        <?php
                        if ($rec_count_detail > 5) {
                            echo '<ul class="pagination">';

                            if ($rec_count > $rec_limit) {

                                if ($page > 0 && $left_rec > $rec_limit) {

                                    $last = $page - 2;

                                    echo '<li><a href="' . $_SERVER["PHP_SELF"] . '?aff_mn=1&page=' . $last . '&srch_value=' . $value . '" class="anc_click">Prev</a></li> ';

                                    echo '<li><a href="' . $_SERVER["PHP_SELF"] . '?aff_mn=1&page=' . $page . '&srch_value=' . $value . '" class="anc_click">Next</a></li>';
                                } else if ($page == 0) {

                                    echo '<li><a href="' . $_SERVER["PHP_SELF"] . '?aff_mn=1&page=' . $page . '&srch_value=' . $value . '" class="anc_click">Next</a></li>';
                                } else if ($left_rec < $rec_limit || $left_rec == $rec_limit) {

                                    $last = $page - 2;

                                    echo '<li><a href="' . $_SERVER["PHP_SELF"] . '?aff_mn=1&page=' . $last . '&srch_value=' . $value . '" class="anc_click">Prev</a></li>';
                                }
                            }

                            echo '</ul>';
                        }
                        ?>

                    </div>

                </div>

            </div><!--/col-->



        </div><!--/row-->


    </div><!-- End Box Div-->

</div><!-- End Middle Content Div-->

<?php include_once('footer.php'); ?>

<script type="text/javascript" src="inner_js/bootstrap-datepicker.min.js"></script>

<script>
                                                    $(document).ready(function() {
                                                        $('.date-picker').datepicker();


                                                        $('#from_date').datepicker({
                                                            format: 'yyyy-mm-dd'
                                                        }).on('changeDate', function(e) {
                                                            $(this).datepicker('hide');
                                                        });

                                                        $('#to_date').datepicker({
                                                            format: 'yyyy-mm-dd'
                                                        }).on('changeDate', function(e) {
                                                            $(this).datepicker('hide');
                                                        });

                                                        $("#total_amount").change(function() {
                                                            var total_amount = $("#total_amount").val();
                                                            var tds_per = $("#tds").val();
                                                            var pending_amount = $("#pending_amount").val();
                                                            var tds_amount = (parseInt(total_amount) * parseInt(tds_per)) / 100;
                                                            var final_Amount = parseInt(total_amount) - parseInt(tds_amount);
                                                            if (total_amount != '') {
                                                                //alert(final_Amount+"==="+pending_amount);
                                                                if (final_Amount > pending_amount) {
                                                                    alert('please enter amount less then pending amount');
                                                                }
                                                                $("#total_amount_with_tds").val(final_Amount);
                                                            }


                                                        });


                                                        $("#add_bank_detail").click(function() {
                                                            var bank_name = $("#bank_name").val();
                                                            var account_number = $("#account_number").val();
                                                            var transaction_id = $("#transaction_id").val();
                                                            var pending_amount = $("#pending_amount").val();
                                                            var total_amount = $("#total_amount").val();
                                                            var total_amount_with_tds = $("#total_amount_with_tds").val();
                                                            var at_date = $("#at_date").val();
                                                            //var paypal_name = $("#b_paypal_name").val();
                                                            var regex = /(\d.*){10}/;
                                                            if (bank_name == '') {
                                                                alert('Please enter bank name');
                                                                $('#bank_name').focus();
                                                                return (false);
                                                            } else if (account_number == '') {
                                                                alert('Please enter account no');
                                                                $('#account_number').focus();
                                                                return (false);
                                                            } else if (transaction_id == '') {
                                                                alert('Please enter transaction id');
                                                                $('#withdraw').focus();
                                                                return (false);
                                                            } else if (pending_amount == '') {
                                                                alert('Please enter pending amount');
                                                                $('#pending_amount').focus();
                                                                return (false);
                                                            } else if (total_amount == '') {
                                                                alert('Please enter total amount');
                                                                $('#total_amount').focus();
                                                                return (false);

                                                            } else if (parseInt(total_amount_with_tds) > parseInt(pending_amount)) {
                                                                alert('please enter amount less then pending amount');
                                                                $('#total_amount').focus();
                                                                return (false);
                                                            } else if (at_date == '') {
                                                                alert('Please enter date');
                                                                $('#at_date').focus();
                                                                return (false);
                                                            } else {
                                                                $("#add_aff_bank_detail").submit();
                                                            }

                                                        });




                                                    });
</script>